<h1>Fixture Balonmano Masculino</h1>

<?php //echo $fecha=CHtml::dropDownList('GeneroBalonmano','',CHtml::listData(RPrograma::model()->findAll(array('order'=>'grid_programa_fecha')),'grid_programa_fecha','grid_programa_fecha'),array('promt'=>'Seleccionar')); ?>
<!--  <br /><br /> -->
	<?php

	$connection = Yii::app()->db;
	
	$command = $connection->createCommand("
	SELECT DISTINCT grid_programa_fecha AS fecha
	FROM grid_r_programa

	ORDER BY grid_programa_fecha, grid_programa_hora
	");
		
	$dataReader = $command->query();

	$datos = $dataReader->readAll();
	
	foreach ($datos as $dato)
	{
		echo $fecha = $dato['fecha']."<br />"; 
	}
	
	?>
<br />
<table>
	<tr class="yellow">
		<td class="adjacent">HORA DEL ENCUENTRO</td>
		<td class="adjacent">ACTUARIOS</td>	
		<td class="adjacent">LUGAR</td>		
	</tr>

<?php $this->widget('zii.widgets.CListView', array(
	'dataProvider'=>$dataProvider,
	'itemView'=>'formatoFixtureBalonmano',
)); ?>
	<?php
		//foreach($dataProvider->getData() as $data)
		//{
		//}
	
	?>

</table>